Learn T-SQL From Scratch: An Easy-to-Follow Guide for Designing, Developing, and Deploying Databases in the SQL Server and Writing T-SQL Queries Efficiently by Brahmanand Shukla

Author:Brahmanand Shukla [Shuklan Brahmanand]
Language: eng
Format: epub
Publisher: BPB Publications
Published: 2022-08-15T00:00:00+00:00

Figure 6.17: Right Outer Join – All the rows from right table and only matching rows from the left table

RIGHT JOIN can be also used to get the rows from right table, if the join condition does not have any matching row in the left table. It can be understood from the following diagram:

Figure 6.18: Right Outer Join – All the rows from right table, only if no matching rows in the left table

Let’s now try query with RIGHT JOIN between Customer and PurchaseOrder tables. Here is the query:

SELECT C.*

, P.*

FROM Customer C

RIGHT JOIN PurchaseOrder P

ON C.CustomerID = P.CustomerID

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.